﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static System.Windows.Forms.VisualStyles.VisualStyleElement;

namespace Gl_mes.DAL.MesDB
{
    [Serializable]
    [Table("OrderCompletion")]
    public class OrderCompletion
    {
		/// <summary>
		/// ID，自增长
		/// </summary>
		[Column("id"),Key]
		[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
		public int id {  get; set; }

		/// <summary>
		/// 生产线
		/// </summary>
		[Column("prod_line")]
		public string prod_line { get; set; }

		/// <summary>
		/// EXCEL中的序号
		/// </summary>
		[Column("table_id")]
		public int table_id { get; set; }

        /// <summary>
        /// 业务员
        /// </summary>
        [Column("sales_user")]
        public string sales_user { get; set; }

        /// <summary>
        /// 计划跟踪号
        /// </summary>
        [Column("track_number")]
        public string track_number {  get; set; }

        /// <summary>
        /// 订单单号
        /// </summary>
        [Column("order_number")]
        public string order_number { get; set; }

		/// <summary>
		/// 生产单号
		/// </summary>
		[Column("prod_number")]
		public string prod_number { get; set; }

        /// <summary>
        /// 主件品号
        /// </summary>
        [Column("goods_number")]
		public string goods_number { get; set; }

        /// <summary>
        /// 品名
        /// </summary>
        [Column("goods_name")]
        public string goods_name { get; set; }

        /// <summary>
        /// 订单数量
        /// </summary>
        [Column("order_qty")]
        public decimal? order_qty { get; set; }


        /// <summary>
        /// 长度
        /// </summary>
        [Column("goods_length")]
        public string goods_length { get; set; }

        /// <summary>
        /// 生产性质
        /// </summary>
        [Column("prod_nature")]
        public string prod_nature { get; set; }

        /// <summary>
        /// 测试.投产日期
        /// </summary>
        [Column("test_date")]
        public DateTime? test_date { get; set; }

        /// <summary>
        /// 测试.日产量
        /// </summary>
        [Column("test_day_qty")]
        public decimal? test_day_qty { get; set; }

        /// <summary>
        /// 测试.投产日期
        /// </summary>
        [Column("pack_date")]
        public DateTime? pack_date { get; set; }

        /// <summary>
        /// 包装.日产量
        /// </summary>
        [Column("pack_day_qty")]
        public decimal? pack_day_qty { get; set; }

        /// <summary>
        /// 完工数量
        /// </summary>
        [Column("clear_qty")]
        public decimal? clear_qty { get; set; }

        /// <summary>
        /// 异常数量
        /// </summary>
        [Column("err_qty")]
        public decimal? err_qty { get; set; }

        /// <summary>
        /// 未完成数量
        /// </summary>
        [Column("surp_qty")]
        public decimal? surp_qty { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [Column("remark")]
        public string remark { get; set; }

        /// <summary>
        /// 导入日期
        /// </summary>
        [Column("create_date")]
        public DateTime? create_date { get; set; }

        /// <summary>
        /// 建档人
        /// </summary>
        [Column("create_user")]
        public string create_user { get; set; }
    }
}
